You are here: Main Menu > I. Interface Menu > 7. External System > D. ESI Profit Projections

ESI Profit Projections

The ESI Weekly Profit Projections function exports the information saved when the weekly profit projection report is updated. See Weekly Profit Projections report for more information.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Year field, enter the accounting year for the ESI profit projections file.

3. At the Week Ending Date field, enter the week ending date for the ESI profit projections file.

Note: The week ending date must be a Saturday. If the date entered is not a Saturday, the following message will display: "Date must be a (day of the week)!!! Space bar to continue" – based on the Ending Day of the Week setting in Ledger Options.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the Period field.
Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print report? No/Yes."

Select no to generate the export file without a printed detail report.
Select yes to create the file with a printed detail report.

5. The following message will appear: "Create a delimited ASC file? No/Yes."

Select no to create a DBF file only. Command options will appear allowing you to print or choose from a set of other print options.
Select yes to create a DBF file and an ASC file.

If you selected yes in Step #4 to print an ESI profit projections report, command options will appear allowing you to print or choose from a set of other print options.

Two DBF files will be created PPMMDDYYYY.dbf and PP_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The PPMMDDYYYY.dbf file is the ESI Weekly profit projection file for the selected week end date with MMDDYYYY equal to the week end date selected. The PP_Last.dbf is a copy of the current file. If an ASC file is created the name will be PPMMDDYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

The following information will print:

Sales Rep and Broker Section

A listing of sales reps – This section lists all sales reps. It also displays the sales reps' current week and month-to-date sales and gross profit percent/dollars.
Listing of brokers – This section lists all brokers. It also displays the current week and month-to-date sales and gross profit percent/dollars.
Listing of sales categories – This section lists all sales categories and displays their current week and month-to-date sales and gross profit percent/dollars.
Listing of all buyer/category managers – This section lists all buyers/category managers and displays their current week and month-to-date sales and gross profit percent/dollars.
Adjustment – These fields display the current week and month-to-date sales adjustments and gross profit percent/dollars that have been made through the Change command option.
Total changes – These fields display the total sales and the gross profit percent/dollars for the current week and for the month-to-date.

Gross Margin Adjustment Section

Inventory Adjustments – These fields display the current week and month-to-date gross profit percent/dollars for adjustments made to inventory by inventory adjustment type.
Selling – These fields display the total for operating expenses designated as "Selling" (ledger/account) by current week budget, history, actual, and by month-to-date budget, history, and actual.
Selling other – These fields display the total for operating expenses designated as "Selling Other” (ledger/account) by current week budget, history, actual and by month-to-date budget, history, and actual.
G&A – These fields display the total for operating expenses designated as “General & Administrative” (ledger/account).
Adjustment – These fields display the total adjustments that have made throughout the Change command option.
Operating expense – These fields display the total operating expenses by current week gross profit percent/dollars and month-to-date percent/dollars.
Operating income – These fields display the total operating income by current week gross profit percent/dollars and month-to-date percent/dollars.

Operating Expenses Section

Plant – These fields display the total operating expenses designated as “Plant” (ledger/account) by current week budget, history, actual and by month-to-date budget, history, and actual.
Selling – These fields display the total for operating expenses designated as “Selling” (ledger/account) by current week budget, history, actual and by month-to-date budget, history, and actual.
Selling other – These fields display the total for operating expenses designated as "Selling Other” (ledger/account) by current week budget, history, actual and by month-to-date budget, history, and actual.
G&A – These fields display the total for operating expenses designated as “General & Administrative” (ledger/account).
Adjustment – These fields display the total adjustments that you have made throughout the Change command option.
Operating expense – These fields display the total operating expenses by current week gross profit percent\dollars and month-to-date percent\dollars.
Operating income – These fields display the total operating income by current week gross profit percent\dollars and month-to-date percent\dollars.

The following table fields will be exported from the system:

Field Name	Description	Type
YEAR	The accounting year	C 4
WEEK END	The week end date	C 8
TRAN TYPE	1 – Sales rep sales 2 – Broker sales 3 – Sales by sales category 4 – Sales by category manager or buyer 5 – Sales adjustments 6 – Cost of goods sold adjustments – current week 7 – Inventory adjustments by inventory adjustment type – current week 8 – Cost of goods sold adjustments – month-to-date 9 – Inventory adjustments by inventory adjustment type – month-to-date A – Operating expense budget amounts B – Historical average amounts C – Actual operating expense amounts D – Operating expense adjustments – current week E – Operating expense adjustment – month-to-date F – Operating income	C 1
DESC	The transaction type description	C 30
SALES	Total weekly sales for the transaction type	N 12,2
GP PCT	The weekly gross profit dollars for the transaction type	N 12, 2
GP DOL	The weekly gross profit dollars for the transaction type	N 12, 2
MTD SALES	The month-to-date sales for the transaction type	N 13, 2
MTD GP PCT	The month-to-date gross profit percentage for the transaction type	N 7, 2
MTD GP DOL	The month-to-date gross profit dollars for the transaction type	N 13, 2
OPEXP BDG	The total month-to-date budget amount for the expense types	N 13, 2
OPEXP HX	The historical cost average for the expense types	N 13, 2
OPEXP ACT	The month-to-date actual operating expense for the expense type	N 13, 2
OPEN MTD	The month-to-date operating expense adjustments	N 13, 2

Security Required : Ledger - Ledger Reports